﻿CREATE TABLE [dbo].[Patient] (
    [PatientId] INT           IDENTITY (1, 1) NOT NULL,
    [FirstName] NVARCHAR (50) NOT NULL,
    [LastName]  VARCHAR (50)  NOT NULL,
    [Address1]  VARCHAR (50)  NOT NULL,
    [Address2]  VARCHAR (50)  NOT NULL,
    [City]      VARCHAR (30)  NOT NULL,
    [State]     CHAR (2)      NOT NULL,
    [Zip]       VARCHAR (9)   NOT NULL,
    [DOB]       SMALLDATETIME NOT NULL,
    [SSN]       CHAR (9)      NULL,
    [Deleted]   BIT           DEFAULT ((0)) NOT NULL,
    PRIMARY KEY CLUSTERED ([PatientId] ASC)
);



